from config.file_url_config import cwd


season_name = "Q2季度"

# 指标表
target_excel_file_name = '专员负责的医院.xlsx'
# 日向数据汇总表
total_excel_file_name = '日更流向数据汇总表.xlsx'
# 匹配医院和专员之后的汇总表
summary_excel_file_name = f"{season_name}销售情况.xlsx"
# 按照专员统计之后的汇总表
specialist_excel_file_name = f"{season_name}专员达标情况.xlsx"
# 按照经理统计之后的汇总表
manager_excel_file_name = f"{season_name}经理达标情况.xlsx"

# 指标表文件夹路径
target_excel_file_prefix = f"{cwd}\\mate\\target_excel_file"
# 日向数据汇总表文件夹路径
total_excel_file_prefix = f"{cwd}\\mate\\total_excel_file"
# 匹配之后的汇总表文件夹路径
summary_excel_file_prefix = f"{cwd}\\mate\\summary_excel_file"


target_excel_file_path = f"{target_excel_file_prefix}\\{target_excel_file_name}"
total_excel_file_path = f"{total_excel_file_prefix}\\{total_excel_file_name}"
summary_excel_file_path = f"{summary_excel_file_prefix}\\{summary_excel_file_name}"
specialist_excel_file_path = f"{summary_excel_file_prefix}\\{specialist_excel_file_name}"
manager_excel_file_path = f"{summary_excel_file_prefix}\\{manager_excel_file_name}"


column_widths = {
    '年份': 15,
    '月份': 10,
    '出库时间': 15,
    '季度': 15,
    '配送商': 30,
    '医院名称': 30,
    '科室': 20,
    '产品内部名称': 40,
    '数量': 10,
    '单价': 15,
    '金额': 20,
    '经理': 20,
    '专员': 20,
}


